package org.clipjoint.dao;

import org.clipjoint.entity.Game;
import org.clipjoint.entity.KeyWord;
import org.clipjoint.entity.User;
import org.clipjoint.entity.dto.GameDto;

import java.sql.SQLException;
import java.util.List;

public interface GameShopDao {
    List<Game> getList(GameDto gameDto, int pricestart, int priceend) throws SQLException;

    Long getCount(GameDto gameDto, int pricestart, int priceend) throws SQLException;

    Game getOne(Game game) throws SQLException;

    int addDream(Long id, Game game) throws SQLException;

    int buy(User user, Game game, String keyword) throws SQLException;

    int update(User user) throws SQLException;

    void delDream(User user, Game game) throws SQLException;

    KeyWord getKey(Long gameid) throws SQLException;

    void updateKey(String keyword) throws SQLException;

    void remove(Long id, Long gameid) throws SQLException;
}
